Dataset statistics
| Number of variables | 23 |
|---|---|
| Number of observations | 35829 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 6.3 MiB |
| Average record size in memory | 184.0 B |
Variable types
| Numeric | 9 |
|---|---|
| Categorical | 10 |
| Boolean | 4 |
points_in_wallet is highly correlated with churn_risk_score | High correlation |
churn_risk_score is highly correlated with points_in_wallet | High correlation |
used_special_discount is highly correlated with offer_application_preference | High correlation |
offer_application_preference is highly correlated with used_special_discount | High correlation |
points_in_wallet is highly correlated with churn_risk_score | High correlation |
feedback is highly correlated with churn_risk_score | High correlation |
membership_category is highly correlated with churn_risk_score | High correlation |
complaint_status is highly correlated with past_complaint | High correlation |
past_complaint is highly correlated with complaint_status | High correlation |
churn_risk_score is highly correlated with points_in_wallet and 3 other fields | High correlation |
avg_transaction_value is highly correlated with churn_risk_score | High correlation |
complaint_status is highly correlated with past_complaint | High correlation |
used_special_discount is highly correlated with offer_application_preference | High correlation |
offer_application_preference is highly correlated with used_special_discount | High correlation |
past_complaint is highly correlated with complaint_status | High correlation |
churn_risk_score is highly correlated with feedback | High correlation |
feedback is highly correlated with churn_risk_score | High correlation |
df_index is uniformly distributed | Uniform |
df_index has unique values | Unique |
Reproduction
| Analysis started | 2021-06-27 21:05:50.465923 |
|---|---|
| Analysis finished | 2021-06-27 21:06:13.940417 |
| Duration | 23.47 seconds |
| Software version | pandas-profiling v3.0.0 |
| Download configuration | config.json |
| Distinct | 35829 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18498.27815 |
| Minimum | 0 |
|---|---|
| Maximum | 36991 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 280.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1860.4 |
| Q1 | 9254 |
| median | 18482 |
| Q3 | 27766 |
| 95-th percentile | 35134.6 |
| Maximum | 36991 |
| Range | 36991 |
| Interquartile range (IQR) | 18512 |
Descriptive statistics
| Standard deviation | 10676.32789 |
|---|---|
| Coefficient of variation (CV) | 0.5771525222 |
| Kurtosis | -1.200629918 |
| Mean | 18498.27815 |
| Median Absolute Deviation (MAD) | 9256 |
| Skewness | 0.0008948182059 |
| Sum | 662774808 |
| Variance | 113983977.3 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 33445 | 1 | < 0.1% |
| 31386 | 1 | < 0.1% |
| 19100 | 1 | < 0.1% |
| 17053 | 1 | < 0.1% |
| 23198 | 1 | < 0.1% |
| 21151 | 1 | < 0.1% |
| 35492 | 1 | < 0.1% |
| 10928 | 1 | < 0.1% |
| 27320 | 1 | < 0.1% |
| Other values (35819) | 35819 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 |
| Value | Count | Frequency (%) |
| 36991 | 1 | |
| 36990 | 1 | |
| 36989 | 1 | |
| 36988 | 1 | |
| 36987 | 1 | |
| 36986 | 1 | |
| 36985 | 1 | |
| 36984 | 1 | |
| 36983 | 1 | |
| 36982 | 1 |
age
Real number (ℝ≥0)
| Distinct | 55 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 37.12026571 |
| Minimum | 10 |
|---|---|
| Maximum | 64 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 280.0 KiB |
Quantile statistics
| Minimum | 10 |
|---|---|
| 5-th percentile | 12 |
| Q1 | 23 |
| median | 37 |
| Q3 | 51 |
| 95-th percentile | 62 |
| Maximum | 64 |
| Range | 54 |
| Interquartile range (IQR) | 28 |
Descriptive statistics
| Standard deviation | 15.86535957 |
|---|---|
| Coefficient of variation (CV) | 0.4274042566 |
| Kurtosis | -1.198183 |
| Mean | 37.12026571 |
| Median Absolute Deviation (MAD) | 14 |
| Skewness | -0.007266793459 |
| Sum | 1329982 |
| Variance | 251.7096342 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 33 | 698 | 1.9% |
| 38 | 692 | 1.9% |
| 16 | 692 | 1.9% |
| 42 | 690 | 1.9% |
| 30 | 688 | 1.9% |
| 61 | 686 | 1.9% |
| 60 | 681 | 1.9% |
| 57 | 678 | 1.9% |
| 59 | 674 | 1.9% |
| 28 | 673 | 1.9% |
| Other values (45) | 28977 |
| Value | Count | Frequency (%) |
| 10 | 649 | |
| 11 | 631 | |
| 12 | 646 | |
| 13 | 625 | |
| 14 | 653 | |
| 15 | 631 | |
| 16 | 692 | |
| 17 | 662 | |
| 18 | 604 | |
| 19 | 632 |
| Value | Count | Frequency (%) |
| 64 | 652 | |
| 63 | 634 | |
| 62 | 658 | |
| 61 | 686 | |
| 60 | 681 | |
| 59 | 674 | |
| 58 | 661 | |
| 57 | 678 | |
| 56 | 662 | |
| 55 | 669 |
gender
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 280.0 KiB |
| F | |
|---|---|
| M |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 35829 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | F |
|---|---|
| 2nd row | F |
| 3rd row | F |
| 4th row | M |
| 5th row | F |
Common Values
| Value | Count | Frequency (%) |
| F | 17948 | |
| M | 17881 |
Length
Pie chart
| Value | Count | Frequency (%) |
| f | 17948 | |
| m | 17881 |
Most occurring characters
| Value | Count | Frequency (%) |
| F | 17948 | |
| M | 17881 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 35829 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| F | 17948 | |
| M | 17881 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 35829 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| F | 17948 | |
| M | 17881 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 35829 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| F | 17948 | |
| M | 17881 |
region_category
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 280.0 KiB |
| Town | |
|---|---|
| City | |
| Village |
Length
| Max length | 7 |
|---|---|
| Median length | 4 |
| Mean length | 4.380892573 |
| Min length | 4 |
Characters and Unicode
| Total characters | 156963 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Village |
|---|---|
| 2nd row | City |
| 3rd row | Town |
| 4th row | City |
| 5th row | City |
Common Values
| Value | Count | Frequency (%) |
| Town | 18965 | |
| City | 12315 | |
| Village | 4549 | 12.7% |
Length
Pie chart
| Value | Count | Frequency (%) |
| town | 18965 | |
| city | 12315 | |
| village | 4549 | 12.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| T | 18965 | |
| o | 18965 | |
| w | 18965 | |
| n | 18965 | |
| i | 16864 | |
| C | 12315 | |
| t | 12315 | |
| y | 12315 | |
| l | 9098 | |
| V | 4549 | 2.9% |
| Other values (3) | 13647 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 121134 | |
| Uppercase Letter | 35829 | 22.8% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 18965 | |
| w | 18965 | |
| n | 18965 | |
| i | 16864 | |
| t | 12315 | |
| y | 12315 | |
| l | 9098 | |
| a | 4549 | 3.8% |
| g | 4549 | 3.8% |
| e | 4549 | 3.8% |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 18965 | |
| C | 12315 | |
| V | 4549 | 12.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 156963 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| T | 18965 | |
| o | 18965 | |
| w | 18965 | |
| n | 18965 | |
| i | 16864 | |
| C | 12315 | |
| t | 12315 | |
| y | 12315 | |
| l | 9098 | |
| V | 4549 | 2.9% |
| Other values (3) | 13647 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 156963 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| T | 18965 | |
| o | 18965 | |
| w | 18965 | |
| n | 18965 | |
| i | 16864 | |
| C | 12315 | |
| t | 12315 | |
| y | 12315 | |
| l | 9098 | |
| V | 4549 | 2.9% |
| Other values (3) | 13647 |
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 280.0 KiB |
| Basic Membership | |
|---|---|
| No Membership | |
| Gold Membership | |
| Silver Membership | |
| Premium Membership |
Length
| Max length | 19 |
|---|---|
| Median length | 16 |
| Mean length | 15.94574228 |
| Min length | 13 |
Characters and Unicode
| Total characters | 571320 |
|---|---|
| Distinct characters | 24 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Platinum Membership |
|---|---|
| 2nd row | Premium Membership |
| 3rd row | No Membership |
| 4th row | No Membership |
| 5th row | No Membership |
Common Values
| Value | Count | Frequency (%) |
| Basic Membership | 7473 | |
| No Membership | 7466 | |
| Gold Membership | 6574 | |
| Silver Membership | 5806 | |
| Premium Membership | 4308 | |
| Platinum Membership | 4202 |
Length
Pie chart
| Value | Count | Frequency (%) |
| membership | 35829 | |
| basic | 7473 | 10.4% |
| no | 7466 | 10.4% |
| gold | 6574 | 9.2% |
| silver | 5806 | 8.1% |
| premium | 4308 | 6.0% |
| platinum | 4202 | 5.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 81772 | |
| i | 57618 | |
| m | 48647 | |
| r | 45943 | 8.0% |
| s | 43302 | 7.6% |
| 35829 | 6.3% | |
| M | 35829 | 6.3% |
| b | 35829 | 6.3% |
| h | 35829 | 6.3% |
| p | 35829 | 6.3% |
| Other values (14) | 114893 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 463833 | |
| Uppercase Letter | 71658 | 12.5% |
| Space Separator | 35829 | 6.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 81772 | |
| i | 57618 | |
| m | 48647 | |
| r | 45943 | |
| s | 43302 | |
| b | 35829 | |
| h | 35829 | |
| p | 35829 | |
| l | 16582 | 3.6% |
| o | 14040 | 3.0% |
| Other values (7) | 48442 |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 35829 | |
| P | 8510 | 11.9% |
| B | 7473 | 10.4% |
| N | 7466 | 10.4% |
| G | 6574 | 9.2% |
| S | 5806 | 8.1% |
Space Separator
| Value | Count | Frequency (%) |
| 35829 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 535491 | |
| Common | 35829 | 6.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 81772 | |
| i | 57618 | |
| m | 48647 | |
| r | 45943 | |
| s | 43302 | |
| M | 35829 | 6.7% |
| b | 35829 | 6.7% |
| h | 35829 | 6.7% |
| p | 35829 | 6.7% |
| l | 16582 | 3.1% |
| Other values (13) | 98311 |
Common
| Value | Count | Frequency (%) |
| 35829 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 571320 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 81772 | |
| i | 57618 | |
| m | 48647 | |
| r | 45943 | 8.0% |
| s | 43302 | 7.6% |
| 35829 | 6.3% | |
| M | 35829 | 6.3% |
| b | 35829 | 6.3% |
| h | 35829 | 6.3% |
| p | 35829 | 6.3% |
| Other values (14) | 114893 |
joined_through_referral
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 35.1 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 20646 | |
| True | 15183 |
preferred_offer_types
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 280.0 KiB |
| Gift Vouchers/Coupons | |
|---|---|
| Credit/Debit Card Offers | |
| Without Offers |
Length
| Max length | 24 |
|---|---|
| Median length | 21 |
| Mean length | 19.70406654 |
| Min length | 14 |
Characters and Unicode
| Total characters | 705977 |
|---|---|
| Distinct characters | 23 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Gift Vouchers/Coupons |
|---|---|
| 2nd row | Gift Vouchers/Coupons |
| 3rd row | Gift Vouchers/Coupons |
| 4th row | Gift Vouchers/Coupons |
| 5th row | Credit/Debit Card Offers |
Common Values
| Value | Count | Frequency (%) |
| Gift Vouchers/Coupons | 12253 | |
| Credit/Debit Card Offers | 11860 | |
| Without Offers | 11716 |
Length
Pie chart
| Value | Count | Frequency (%) |
| offers | 23576 | |
| vouchers/coupons | 12253 | |
| gift | 12253 | |
| credit/debit | 11860 | |
| card | 11860 | |
| without | 11716 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 59549 | 8.4% |
| r | 59549 | 8.4% |
| f | 59405 | 8.4% |
| t | 59405 | 8.4% |
| o | 48475 | 6.9% |
| s | 48082 | 6.8% |
| i | 47689 | 6.8% |
| 47689 | 6.8% | |
| u | 36222 | 5.1% |
| C | 35973 | 5.1% |
| Other values (13) | 203939 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 526544 | |
| Uppercase Letter | 107631 | 15.2% |
| Space Separator | 47689 | 6.8% |
| Other Punctuation | 24113 | 3.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 59549 | |
| r | 59549 | |
| f | 59405 | |
| t | 59405 | |
| o | 48475 | |
| s | 48082 | |
| i | 47689 | |
| u | 36222 | |
| h | 23969 | 4.6% |
| d | 23720 | 4.5% |
| Other values (5) | 60479 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 35973 | |
| O | 23576 | |
| G | 12253 | 11.4% |
| V | 12253 | 11.4% |
| D | 11860 | 11.0% |
| W | 11716 | 10.9% |
Space Separator
| Value | Count | Frequency (%) |
| 47689 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 24113 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 634175 | |
| Common | 71802 | 10.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 59549 | 9.4% |
| r | 59549 | 9.4% |
| f | 59405 | 9.4% |
| t | 59405 | 9.4% |
| o | 48475 | 7.6% |
| s | 48082 | 7.6% |
| i | 47689 | 7.5% |
| u | 36222 | 5.7% |
| C | 35973 | 5.7% |
| h | 23969 | 3.8% |
| Other values (11) | 155857 |
Common
| Value | Count | Frequency (%) |
| 47689 | ||
| / | 24113 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 705977 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 59549 | 8.4% |
| r | 59549 | 8.4% |
| f | 59405 | 8.4% |
| t | 59405 | 8.4% |
| o | 48475 | 6.9% |
| s | 48082 | 6.8% |
| i | 47689 | 6.8% |
| 47689 | 6.8% | |
| u | 36222 | 5.1% |
| C | 35973 | 5.1% |
| Other values (13) | 203939 |
medium_of_operation
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 280.0 KiB |
| Desktop | |
|---|---|
| Smartphone | |
| Both |
Length
| Max length | 10 |
|---|---|
| Median length | 7 |
| Mean length | 7.81763376 |
| Min length | 4 |
Characters and Unicode
| Total characters | 280098 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Desktop |
|---|---|
| 2nd row | Desktop |
| 3rd row | Desktop |
| 4th row | Desktop |
| 5th row | Smartphone |
Common Values
| Value | Count | Frequency (%) |
| Desktop | 18706 | |
| Smartphone | 13444 | |
| Both | 3679 | 10.3% |
Length
Pie chart
| Value | Count | Frequency (%) |
| desktop | 18706 | |
| smartphone | 13444 | |
| both | 3679 | 10.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 35829 | |
| o | 35829 | |
| e | 32150 | |
| p | 32150 | |
| D | 18706 | |
| s | 18706 | |
| k | 18706 | |
| h | 17123 | 6.1% |
| S | 13444 | 4.8% |
| m | 13444 | 4.8% |
| Other values (4) | 44011 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 244269 | |
| Uppercase Letter | 35829 | 12.8% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 35829 | |
| o | 35829 | |
| e | 32150 | |
| p | 32150 | |
| s | 18706 | |
| k | 18706 | |
| h | 17123 | |
| m | 13444 | 5.5% |
| a | 13444 | 5.5% |
| r | 13444 | 5.5% |
Uppercase Letter
| Value | Count | Frequency (%) |
| D | 18706 | |
| S | 13444 | |
| B | 3679 | 10.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 280098 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 35829 | |
| o | 35829 | |
| e | 32150 | |
| p | 32150 | |
| D | 18706 | |
| s | 18706 | |
| k | 18706 | |
| h | 17123 | 6.1% |
| S | 13444 | 4.8% |
| m | 13444 | 4.8% |
| Other values (4) | 44011 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 280098 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| t | 35829 | |
| o | 35829 | |
| e | 32150 | |
| p | 32150 | |
| D | 18706 | |
| s | 18706 | |
| k | 18706 | |
| h | 17123 | 6.1% |
| S | 13444 | 4.8% |
| m | 13444 | 4.8% |
| Other values (4) | 44011 |
internet_option
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 280.0 KiB |
| Wi-Fi | |
|---|---|
| Mobile_Data | |
| Fiber_Optic |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 8.987775266 |
| Min length | 5 |
Characters and Unicode
| Total characters | 322023 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Wi-Fi |
|---|---|
| 2nd row | Mobile_Data |
| 3rd row | Wi-Fi |
| 4th row | Mobile_Data |
| 5th row | Mobile_Data |
Common Values
| Value | Count | Frequency (%) |
| Wi-Fi | 12016 | |
| Mobile_Data | 11953 | |
| Fiber_Optic | 11860 |
Length
Pie chart
| Value | Count | Frequency (%) |
| wi-fi | 12016 | |
| mobile_data | 11953 | |
| fiber_optic | 11860 |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 59705 | |
| a | 23906 | 7.4% |
| F | 23876 | 7.4% |
| b | 23813 | 7.4% |
| e | 23813 | 7.4% |
| _ | 23813 | 7.4% |
| t | 23813 | 7.4% |
| W | 12016 | 3.7% |
| - | 12016 | 3.7% |
| M | 11953 | 3.7% |
| Other values (7) | 83299 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 214536 | |
| Uppercase Letter | 71658 | 22.3% |
| Connector Punctuation | 23813 | 7.4% |
| Dash Punctuation | 12016 | 3.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 59705 | |
| a | 23906 | |
| b | 23813 | 11.1% |
| e | 23813 | 11.1% |
| t | 23813 | 11.1% |
| o | 11953 | 5.6% |
| l | 11953 | 5.6% |
| r | 11860 | 5.5% |
| p | 11860 | 5.5% |
| c | 11860 | 5.5% |
Uppercase Letter
| Value | Count | Frequency (%) |
| F | 23876 | |
| W | 12016 | |
| M | 11953 | |
| D | 11953 | |
| O | 11860 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 12016 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 23813 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 286194 | |
| Common | 35829 | 11.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| i | 59705 | |
| a | 23906 | |
| F | 23876 | 8.3% |
| b | 23813 | 8.3% |
| e | 23813 | 8.3% |
| t | 23813 | 8.3% |
| W | 12016 | 4.2% |
| M | 11953 | 4.2% |
| o | 11953 | 4.2% |
| l | 11953 | 4.2% |
| Other values (5) | 59393 |
Common
| Value | Count | Frequency (%) |
| _ | 23813 | |
| - | 12016 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 322023 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| i | 59705 | |
| a | 23906 | 7.4% |
| F | 23876 | 7.4% |
| b | 23813 | 7.4% |
| e | 23813 | 7.4% |
| _ | 23813 | 7.4% |
| t | 23813 | 7.4% |
| W | 12016 | 3.7% |
| - | 12016 | 3.7% |
| M | 11953 | 3.7% |
| Other values (7) | 83299 |
days_since_last_login
Real number (ℝ)
| Distinct | 27 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -42.14390577 |
| Minimum | -999 |
|---|---|
| Maximum | 26 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 1944 |
| Negative (%) | 5.4% |
| Memory size | 280.0 KiB |
Quantile statistics
| Minimum | -999 |
|---|---|
| 5-th percentile | -999 |
| Q1 | 8 |
| median | 12 |
| Q3 | 16 |
| 95-th percentile | 22 |
| Maximum | 26 |
| Range | 1025 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 229.254856 |
|---|---|
| Coefficient of variation (CV) | -5.439810378 |
| Kurtosis | 13.47173094 |
| Mean | -42.14390577 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | -3.931931907 |
| Sum | -1509974 |
| Variance | 52557.78899 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 12 | 2307 | 6.4% |
| 13 | 2288 | 6.4% |
| 14 | 2226 | 6.2% |
| 15 | 2208 | 6.2% |
| 11 | 2195 | 6.1% |
| 10 | 2025 | 5.7% |
| 16 | 2002 | 5.6% |
| -999 | 1944 | 5.4% |
| 9 | 1801 | 5.0% |
| 17 | 1689 | 4.7% |
| Other values (17) | 15144 |
| Value | Count | Frequency (%) |
| -999 | 1944 | |
| 1 | 323 | 0.9% |
| 2 | 590 | 1.6% |
| 3 | 830 | |
| 4 | 967 | |
| 5 | 1190 | |
| 6 | 1222 | |
| 7 | 1406 | |
| 8 | 1529 | |
| 9 | 1801 |
| Value | Count | Frequency (%) |
| 26 | 78 | 0.2% |
| 25 | 197 | 0.5% |
| 24 | 460 | 1.3% |
| 23 | 704 | |
| 22 | 856 | |
| 21 | 992 | |
| 20 | 1140 | |
| 19 | 1275 | |
| 18 | 1385 | |
| 17 | 1689 |
avg_time_spent
Real number (ℝ)
| Distinct | 25299 |
|---|---|
| Distinct (%) | 70.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 243.3738594 |
| Minimum | -2814.10911 |
|---|---|
| Maximum | 3235.578521 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 1659 |
| Negative (%) | 4.6% |
| Memory size | 280.0 KiB |
Quantile statistics
| Minimum | -2814.10911 |
|---|---|
| 5-th percentile | 30.16 |
| Q1 | 59.81 |
| median | 161.62 |
| Q3 | 356.33 |
| 95-th percentile | 1029.421973 |
| Maximum | 3235.578521 |
| Range | 6049.687631 |
| Interquartile range (IQR) | 296.52 |
Descriptive statistics
| Standard deviation | 397.78465 |
|---|---|
| Coefficient of variation (CV) | 1.634459226 |
| Kurtosis | 5.002986165 |
| Mean | 243.3738594 |
| Median Absolute Deviation (MAD) | 123.02 |
| Skewness | 0.5344852285 |
| Sum | 8719842.01 |
| Variance | 158232.6277 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 34.1 | 21 | 0.1% |
| 34.71 | 20 | 0.1% |
| 33.68 | 19 | 0.1% |
| 34.33 | 19 | 0.1% |
| 32.91 | 18 | 0.1% |
| 31.49 | 18 | 0.1% |
| 33.28 | 18 | 0.1% |
| 33.71 | 17 | < 0.1% |
| 33.94 | 17 | < 0.1% |
| 32.96 | 16 | < 0.1% |
| Other values (25289) | 35646 |
| Value | Count | Frequency (%) |
| -2814.10911 | 1 | |
| -2281.236526 | 1 | |
| -2096.580681 | 1 | |
| -2093.121606 | 1 | |
| -2034.80188 | 1 | |
| -2012.267374 | 1 | |
| -1960.479169 | 1 | |
| -1941.035419 | 1 | |
| -1918.486339 | 1 | |
| -1913.405154 | 1 |
| Value | Count | Frequency (%) |
| 3235.578521 | 1 | |
| 3040.41 | 1 | |
| 2899.66 | 1 | |
| 2861.23 | 1 | |
| 2770.56 | 1 | |
| 2747.89134 | 1 | |
| 2732.7 | 1 | |
| 2722.077794 | 1 | |
| 2705.756608 | 1 | |
| 2567.825647 | 1 |
| Distinct | 35741 |
|---|---|
| Distinct (%) | 99.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 29304.27231 |
| Minimum | 800.46 |
|---|---|
| Maximum | 99914.05 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 280.0 KiB |
Quantile statistics
| Minimum | 800.46 |
|---|---|
| 5-th percentile | 3471.128 |
| Q1 | 14194.65 |
| median | 27584.53 |
| Q3 | 40874.01 |
| 95-th percentile | 67690.73 |
| Maximum | 99914.05 |
| Range | 99113.59 |
| Interquartile range (IQR) | 26679.36 |
Descriptive statistics
| Standard deviation | 19484.56542 |
|---|---|
| Coefficient of variation (CV) | 0.6649052813 |
| Kurtosis | 1.427273826 |
| Mean | 29304.27231 |
| Median Absolute Deviation (MAD) | 13329.8 |
| Skewness | 1.014141011 |
| Sum | 1049942772 |
| Variance | 379648289.6 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 30126.02 | 2 | < 0.1% |
| 40490.43 | 2 | < 0.1% |
| 3432.73 | 2 | < 0.1% |
| 26705.4 | 2 | < 0.1% |
| 48790.61 | 2 | < 0.1% |
| 37388.33 | 2 | < 0.1% |
| 27913.3 | 2 | < 0.1% |
| 11573.44 | 2 | < 0.1% |
| 6970.8 | 2 | < 0.1% |
| 39623.1 | 2 | < 0.1% |
| Other values (35731) | 35809 |
| Value | Count | Frequency (%) |
| 800.46 | 1 | |
| 804.34 | 1 | |
| 806.22 | 1 | |
| 806.71 | 1 | |
| 813.82 | 1 | |
| 815.22 | 1 | |
| 821.83 | 1 | |
| 822.7 | 1 | |
| 823.49 | 1 | |
| 823.68 | 1 |
| Value | Count | Frequency (%) |
| 99914.05 | 1 | |
| 99861.47 | 1 | |
| 99858.02 | 1 | |
| 99819.19 | 1 | |
| 99810.83 | 1 | |
| 99805.52 | 1 | |
| 99803.53 | 1 | |
| 99795.75 | 1 | |
| 99742.63 | 1 | |
| 99730.17 | 1 |
avg_frequency_login_days
Real number (ℝ)
| Distinct | 1587 |
|---|---|
| Distinct (%) | 4.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.96304027 |
| Minimum | -43.65270156 |
|---|---|
| Maximum | 73.06199459 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 659 |
| Negative (%) | 1.8% |
| Memory size | 280.0 KiB |
Quantile statistics
| Minimum | -43.65270156 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 10 |
| median | 15.96304027 |
| Q3 | 22 |
| 95-th percentile | 29 |
| Maximum | 73.06199459 |
| Range | 116.7146962 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 8.755654449 |
|---|---|
| Coefficient of variation (CV) | 0.5484954184 |
| Kurtosis | 2.461142555 |
| Mean | 15.96304027 |
| Median Absolute Deviation (MAD) | 5.963040266 |
| Skewness | 0.006513732976 |
| Sum | 571939.7697 |
| Variance | 76.66148483 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 15.96304027 | 3419 | 9.5% |
| 13 | 1361 | 3.8% |
| 8 | 1326 | 3.7% |
| 19 | 1319 | 3.7% |
| 14 | 1315 | 3.7% |
| 6 | 1304 | 3.6% |
| 17 | 1303 | 3.6% |
| 10 | 1296 | 3.6% |
| 18 | 1292 | 3.6% |
| 15 | 1291 | 3.6% |
| Other values (1577) | 20603 |
| Value | Count | Frequency (%) |
| -43.65270156 | 1 | |
| -43.62541346 | 1 | |
| -37.42477814 | 1 | |
| -35.81575763 | 1 | |
| -34.41711527 | 1 | |
| -33.49956331 | 1 | |
| -28.59201152 | 1 | |
| -27.90053779 | 1 | |
| -25.48559107 | 1 | |
| -25.36616806 | 1 |
| Value | Count | Frequency (%) |
| 73.06199459 | 1 | |
| 67.06242197 | 1 | |
| 63.52353736 | 1 | |
| 56.53847804 | 1 | |
| 56.16197924 | 1 | |
| 56.04658611 | 1 | |
| 55.65239647 | 1 | |
| 55.42285257 | 1 | |
| 55.37627229 | 1 | |
| 55.12785548 | 1 |
| Distinct | 23162 |
|---|---|
| Distinct (%) | 64.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 686.8492312 |
| Minimum | -760.6612363 |
|---|---|
| Maximum | 2069.069761 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 134 |
| Negative (%) | 0.4% |
| Memory size | 280.0 KiB |
Quantile statistics
| Minimum | -760.6612363 |
|---|---|
| 5-th percentile | 350.3458545 |
| Q1 | 624.31 |
| median | 686.8492312 |
| Q3 | 757.09 |
| 95-th percentile | 1029.333759 |
| Maximum | 2069.069761 |
| Range | 2829.730997 |
| Interquartile range (IQR) | 132.78 |
Descriptive statistics
| Standard deviation | 185.2803719 |
|---|---|
| Coefficient of variation (CV) | 0.2697540646 |
| Kurtosis | 5.189221456 |
| Mean | 686.8492312 |
| Median Absolute Deviation (MAD) | 66.77923123 |
| Skewness | -0.09146186137 |
| Sum | 24609121.11 |
| Variance | 34328.81621 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 686.8492312 | 3341 | 9.3% |
| 705.07 | 9 | < 0.1% |
| 780.92 | 8 | < 0.1% |
| 771.75 | 7 | < 0.1% |
| 760.54 | 7 | < 0.1% |
| 783.42 | 6 | < 0.1% |
| 719.78 | 6 | < 0.1% |
| 719.39 | 6 | < 0.1% |
| 734.4 | 6 | < 0.1% |
| 756.91 | 6 | < 0.1% |
| Other values (23152) | 32427 |
| Value | Count | Frequency (%) |
| -760.6612363 | 1 | |
| -549.3574977 | 1 | |
| -506.2567158 | 1 | |
| -483.8564006 | 1 | |
| -471.577009 | 1 | |
| -469.0203988 | 1 | |
| -445.2884572 | 1 | |
| -424.6705248 | 1 | |
| -412.4416878 | 1 | |
| -405.2670355 | 1 |
| Value | Count | Frequency (%) |
| 2069.069761 | 1 | |
| 1816.933696 | 1 | |
| 1780.720173 | 1 | |
| 1763.351594 | 1 | |
| 1759.002532 | 1 | |
| 1755.455512 | 1 | |
| 1755.094693 | 1 | |
| 1751.304195 | 1 | |
| 1750.611562 | 1 | |
| 1736.332594 | 1 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 35.1 KiB |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) |
| True | 19718 | |
| False | 16111 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 35.1 KiB |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) |
| True | 19783 | |
| False | 16046 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 35.1 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 18007 | |
| True | 17822 |
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 280.0 KiB |
| Not Applicable | |
|---|---|
| Unsolved | |
| Solved | |
| Solved in Follow-up | |
| No Information Available |
Length
| Max length | 24 |
|---|---|
| Median length | 14 |
| Mean length | 14.10000279 |
| Min length | 6 |
Characters and Unicode
| Total characters | 505189 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Not Applicable |
|---|---|
| 2nd row | Solved |
| 3rd row | Solved in Follow-up |
| 4th row | Unsolved |
| 5th row | Solved |
Common Values
| Value | Count | Frequency (%) |
| Not Applicable | 18007 | |
| Unsolved | 4501 | 12.6% |
| Solved | 4467 | 12.5% |
| Solved in Follow-up | 4443 | 12.4% |
| No Information Available | 4411 | 12.3% |
Length
Pie chart
| Value | Count | Frequency (%) |
| applicable | 18007 | |
| not | 18007 | |
| solved | 8910 | |
| unsolved | 4501 | 6.3% |
| follow-up | 4443 | 6.2% |
| in | 4443 | 6.2% |
| no | 4411 | 6.2% |
| information | 4411 | 6.2% |
| available | 4411 | 6.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 67133 | |
| o | 53537 | 10.6% |
| p | 40457 | 8.0% |
| e | 35829 | 7.1% |
| 35715 | 7.1% | |
| i | 31272 | 6.2% |
| a | 31240 | 6.2% |
| N | 22418 | 4.4% |
| t | 22418 | 4.4% |
| A | 22418 | 4.4% |
| Other values (16) | 142752 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 397930 | |
| Uppercase Letter | 67101 | 13.3% |
| Space Separator | 35715 | 7.1% |
| Dash Punctuation | 4443 | 0.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| l | 67133 | |
| o | 53537 | |
| p | 40457 | |
| e | 35829 | |
| i | 31272 | |
| a | 31240 | |
| t | 22418 | 5.6% |
| b | 22418 | 5.6% |
| c | 18007 | 4.5% |
| v | 17822 | 4.5% |
| Other values (8) | 57797 |
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 22418 | |
| A | 22418 | |
| S | 8910 | 13.3% |
| U | 4501 | 6.7% |
| F | 4443 | 6.6% |
| I | 4411 | 6.6% |
Space Separator
| Value | Count | Frequency (%) |
| 35715 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 4443 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 465031 | |
| Common | 40158 | 7.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| l | 67133 | |
| o | 53537 | |
| p | 40457 | 8.7% |
| e | 35829 | 7.7% |
| i | 31272 | 6.7% |
| a | 31240 | 6.7% |
| N | 22418 | 4.8% |
| t | 22418 | 4.8% |
| A | 22418 | 4.8% |
| b | 22418 | 4.8% |
| Other values (14) | 115891 |
Common
| Value | Count | Frequency (%) |
| 35715 | ||
| - | 4443 | 11.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 505189 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| l | 67133 | |
| o | 53537 | 10.6% |
| p | 40457 | 8.0% |
| e | 35829 | 7.1% |
| 35715 | 7.1% | |
| i | 31272 | 6.2% |
| a | 31240 | 6.2% |
| N | 22418 | 4.4% |
| t | 22418 | 4.4% |
| A | 22418 | 4.4% |
| Other values (16) | 142752 |
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 280.0 KiB |
| Poor Product Quality | |
|---|---|
| Too many ads | |
| No reason specified | |
| Poor Website | |
| Poor Customer Service | |
| Other values (4) |
Length
| Max length | 24 |
|---|---|
| Median length | 19 |
| Mean length | 17.35560579 |
| Min length | 12 |
Characters and Unicode
| Total characters | 621834 |
|---|---|
| Distinct characters | 31 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Products always in Stock |
|---|---|
| 2nd row | Quality Customer Care |
| 3rd row | Poor Website |
| 4th row | Poor Website |
| 5th row | Poor Website |
Common Values
| Value | Count | Frequency (%) |
| Poor Product Quality | 6152 | |
| Too many ads | 6096 | |
| No reason specified | 6072 | |
| Poor Website | 6060 | |
| Poor Customer Service | 6056 | |
| Reasonable Price | 1382 | 3.9% |
| User Friendly Website | 1346 | 3.8% |
| Products always in Stock | 1345 | 3.8% |
| Quality Customer Care | 1320 | 3.7% |
Length
Pie chart
| Value | Count | Frequency (%) |
| poor | 18268 | |
| quality | 7472 | 7.4% |
| website | 7406 | 7.3% |
| customer | 7376 | 7.3% |
| product | 6152 | 6.1% |
| too | 6096 | 6.0% |
| many | 6096 | 6.0% |
| ads | 6096 | 6.0% |
| no | 6072 | 6.0% |
| reason | 6072 | 6.0% |
| Other values (11) | 24284 |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 78472 | |
| 65561 | 10.5% | |
| e | 60674 | 9.8% |
| r | 50663 | 8.1% |
| s | 38440 | 6.2% |
| i | 37151 | 6.0% |
| a | 32510 | 5.2% |
| t | 31096 | 5.0% |
| P | 27147 | 4.4% |
| c | 22352 | 3.6% |
| Other values (21) | 177768 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 481909 | |
| Uppercase Letter | 74364 | 12.0% |
| Space Separator | 65561 | 10.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 78472 | |
| e | 60674 | |
| r | 50663 | |
| s | 38440 | |
| i | 37151 | |
| a | 32510 | 6.7% |
| t | 31096 | 6.5% |
| c | 22352 | 4.6% |
| u | 22345 | 4.6% |
| d | 21011 | 4.4% |
| Other values (10) | 87195 |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 27147 | |
| C | 8696 | 11.7% |
| Q | 7472 | 10.0% |
| W | 7406 | 10.0% |
| S | 7401 | 10.0% |
| T | 6096 | 8.2% |
| N | 6072 | 8.2% |
| R | 1382 | 1.9% |
| U | 1346 | 1.8% |
| F | 1346 | 1.8% |
Space Separator
| Value | Count | Frequency (%) |
| 65561 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 556273 | |
| Common | 65561 | 10.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 78472 | |
| e | 60674 | 10.9% |
| r | 50663 | 9.1% |
| s | 38440 | 6.9% |
| i | 37151 | 6.7% |
| a | 32510 | 5.8% |
| t | 31096 | 5.6% |
| P | 27147 | 4.9% |
| c | 22352 | 4.0% |
| u | 22345 | 4.0% |
| Other values (20) | 155423 |
Common
| Value | Count | Frequency (%) |
| 65561 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 621834 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 78472 | |
| 65561 | 10.5% | |
| e | 60674 | 9.8% |
| r | 50663 | 8.1% |
| s | 38440 | 6.2% |
| i | 37151 | 6.0% |
| a | 32510 | 5.2% |
| t | 31096 | 5.0% |
| P | 27147 | 4.4% |
| c | 22352 | 3.6% |
| Other values (21) | 177768 |
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 280.0 KiB |
| 3 | |
|---|---|
| 4 | |
| 5 | |
| 2 | |
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 35829 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2 |
|---|---|
| 2nd row | 1 |
| 3rd row | 5 |
| 4th row | 5 |
| 5th row | 5 |
Common Values
| Value | Count | Frequency (%) |
| 3 | 10424 | |
| 4 | 10185 | |
| 5 | 9827 | |
| 2 | 2741 | 7.7% |
| 1 | 2652 | 7.4% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 3 | 10424 | |
| 4 | 10185 | |
| 5 | 9827 | |
| 2 | 2741 | 7.7% |
| 1 | 2652 | 7.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 3 | 10424 | |
| 4 | 10185 | |
| 5 | 9827 | |
| 2 | 2741 | 7.7% |
| 1 | 2652 | 7.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 35829 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 10424 | |
| 4 | 10185 | |
| 5 | 9827 | |
| 2 | 2741 | 7.7% |
| 1 | 2652 | 7.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 35829 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 3 | 10424 | |
| 4 | 10185 | |
| 5 | 9827 | |
| 2 | 2741 | 7.7% |
| 1 | 2652 | 7.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 35829 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 3 | 10424 | |
| 4 | 10185 | |
| 5 | 9827 | |
| 2 | 2741 | 7.7% |
| 1 | 2652 | 7.4% |
joining_day
Real number (ℝ≥0)
| Distinct | 31 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.68070557 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 280.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 16 |
| Q3 | 23 |
| 95-th percentile | 29 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 8.795512382 |
|---|---|
| Coefficient of variation (CV) | 0.5609130495 |
| Kurtosis | -1.197211874 |
| Mean | 15.68070557 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 0.01515722792 |
| Sum | 561824 |
| Variance | 77.36103806 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5 | 1241 | 3.5% |
| 7 | 1234 | 3.4% |
| 8 | 1219 | 3.4% |
| 27 | 1204 | 3.4% |
| 24 | 1204 | 3.4% |
| 12 | 1202 | 3.4% |
| 23 | 1197 | 3.3% |
| 13 | 1195 | 3.3% |
| 2 | 1195 | 3.3% |
| 19 | 1195 | 3.3% |
| Other values (21) | 23743 |
| Value | Count | Frequency (%) |
| 1 | 1150 | |
| 2 | 1195 | |
| 3 | 1190 | |
| 4 | 1153 | |
| 5 | 1241 | |
| 6 | 1168 | |
| 7 | 1234 | |
| 8 | 1219 | |
| 9 | 1161 | |
| 10 | 1118 |
| Value | Count | Frequency (%) |
| 31 | 672 | |
| 30 | 1072 | |
| 29 | 1089 | |
| 28 | 1162 | |
| 27 | 1204 | |
| 26 | 1137 | |
| 25 | 1145 | |
| 24 | 1204 | |
| 23 | 1197 | |
| 22 | 1192 |
joining_month
Real number (ℝ≥0)
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.53448324 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 280.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 7 |
| Q3 | 10 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.448567238 |
|---|---|
| Coefficient of variation (CV) | 0.5277490372 |
| Kurtosis | -1.203034364 |
| Mean | 6.53448324 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.01465061584 |
| Sum | 234124 |
| Variance | 11.892616 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 7 | 3088 | |
| 12 | 3085 | |
| 1 | 3053 | |
| 8 | 3048 | |
| 10 | 2991 | |
| 9 | 2988 | |
| 3 | 2979 | |
| 6 | 2977 | |
| 5 | 2971 | |
| 4 | 2968 | |
| Other values (2) | 5681 |
| Value | Count | Frequency (%) |
| 1 | 3053 | |
| 2 | 2752 | |
| 3 | 2979 | |
| 4 | 2968 | |
| 5 | 2971 | |
| 6 | 2977 | |
| 7 | 3088 | |
| 8 | 3048 | |
| 9 | 2988 | |
| 10 | 2991 |
| Value | Count | Frequency (%) |
| 12 | 3085 | |
| 11 | 2929 | |
| 10 | 2991 | |
| 9 | 2988 | |
| 8 | 3048 | |
| 7 | 3088 | |
| 6 | 2977 | |
| 5 | 2971 | |
| 4 | 2968 | |
| 3 | 2979 |
joining_year
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 280.0 KiB |
| 2017 | |
|---|---|
| 2015 | |
| 2016 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 143316 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2017 |
|---|---|
| 2nd row | 2017 |
| 3rd row | 2016 |
| 4th row | 2016 |
| 5th row | 2017 |
Common Values
| Value | Count | Frequency (%) |
| 2017 | 12168 | |
| 2015 | 11906 | |
| 2016 | 11755 |
Length
Pie chart
| Value | Count | Frequency (%) |
| 2017 | 12168 | |
| 2015 | 11906 | |
| 2016 | 11755 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 35829 | |
| 0 | 35829 | |
| 1 | 35829 | |
| 7 | 12168 | 8.5% |
| 5 | 11906 | 8.3% |
| 6 | 11755 | 8.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 143316 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 35829 | |
| 0 | 35829 | |
| 1 | 35829 | |
| 7 | 12168 | 8.5% |
| 5 | 11906 | 8.3% |
| 6 | 11755 | 8.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 143316 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 35829 | |
| 0 | 35829 | |
| 1 | 35829 | |
| 7 | 12168 | 8.5% |
| 5 | 11906 | 8.3% |
| 6 | 11755 | 8.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 143316 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 35829 | |
| 0 | 35829 | |
| 1 | 35829 | |
| 7 | 12168 | 8.5% |
| 5 | 11906 | 8.3% |
| 6 | 11755 | 8.2% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| df_index | age | gender | region_category | membership_category | joined_through_referral | preferred_offer_types | medium_of_operation | internet_option | days_since_last_login | avg_time_spent | avg_transaction_value | avg_frequency_login_days | points_in_wallet | used_special_discount | offer_application_preference | past_complaint | complaint_status | feedback | churn_risk_score | joining_day | joining_month | joining_year | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 18 | F | Village | Platinum Membership | No | Gift Vouchers/Coupons | Desktop | Wi-Fi | 17 | 300.63 | 53005.25 | 17.0 | 781.750000 | Yes | Yes | No | Not Applicable | Products always in Stock | 2 | 17 | 8 | 2017 |
| 1 | 1 | 32 | F | City | Premium Membership | No | Gift Vouchers/Coupons | Desktop | Mobile_Data | 16 | 306.34 | 12838.38 | 10.0 | 686.849231 | Yes | No | Yes | Solved | Quality Customer Care | 1 | 28 | 8 | 2017 |
| 2 | 2 | 44 | F | Town | No Membership | Yes | Gift Vouchers/Coupons | Desktop | Wi-Fi | 14 | 516.16 | 21027.00 | 22.0 | 500.690000 | No | Yes | Yes | Solved in Follow-up | Poor Website | 5 | 11 | 11 | 2016 |
| 3 | 3 | 37 | M | City | No Membership | Yes | Gift Vouchers/Coupons | Desktop | Mobile_Data | 11 | 53.27 | 25239.56 | 6.0 | 567.660000 | No | Yes | Yes | Unsolved | Poor Website | 5 | 29 | 10 | 2016 |
| 4 | 4 | 31 | F | City | No Membership | No | Credit/Debit Card Offers | Smartphone | Mobile_Data | 20 | 113.13 | 24483.66 | 16.0 | 663.060000 | No | Yes | Yes | Solved | Poor Website | 5 | 12 | 9 | 2017 |
| 5 | 5 | 13 | M | City | Gold Membership | No | Gift Vouchers/Coupons | Desktop | Wi-Fi | 23 | 433.62 | 13884.77 | 24.0 | 722.270000 | Yes | No | Yes | Unsolved | No reason specified | 3 | 8 | 1 | 2016 |
| 6 | 6 | 21 | M | Town | Gold Membership | Yes | Gift Vouchers/Coupons | Desktop | Mobile_Data | 10 | 55.38 | 8982.50 | 28.0 | 756.210000 | Yes | No | Yes | Solved in Follow-up | No reason specified | 3 | 19 | 3 | 2015 |
| 7 | 7 | 42 | M | Town | No Membership | No | Credit/Debit Card Offers | Both | Fiber_Optic | 19 | 429.11 | 44554.82 | 24.0 | 568.080000 | No | Yes | Yes | Unsolved | Poor Product Quality | 5 | 12 | 7 | 2016 |
| 8 | 8 | 44 | M | Village | Silver Membership | No | Without Offers | Smartphone | Fiber_Optic | 15 | 191.07 | 18362.31 | 20.0 | 686.849231 | Yes | No | Yes | Solved in Follow-up | Poor Customer Service | 3 | 14 | 12 | 2016 |
| 9 | 9 | 45 | F | Town | No Membership | No | Gift Vouchers/Coupons | Desktop | Wi-Fi | 10 | 97.31 | 19244.16 | 28.0 | 706.230000 | No | Yes | Yes | No Information Available | Poor Customer Service | 4 | 30 | 11 | 2016 |
Last rows
| df_index | age | gender | region_category | membership_category | joined_through_referral | preferred_offer_types | medium_of_operation | internet_option | days_since_last_login | avg_time_spent | avg_transaction_value | avg_frequency_login_days | points_in_wallet | used_special_discount | offer_application_preference | past_complaint | complaint_status | feedback | churn_risk_score | joining_day | joining_month | joining_year | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 35819 | 36982 | 45 | F | Town | Premium Membership | No | Gift Vouchers/Coupons | Desktop | Wi-Fi | 10 | 34.930000 | 41558.93 | 19.00000 | 703.030000 | Yes | No | No | Not Applicable | Poor Product Quality | 3 | 31 | 8 | 2016 |
| 35820 | 36983 | 45 | M | Town | Basic Membership | Yes | Without Offers | Smartphone | Wi-Fi | 9 | 49.330000 | 45358.49 | 11.00000 | 242.979625 | Yes | No | No | Not Applicable | Poor Customer Service | 5 | 30 | 8 | 2016 |
| 35821 | 36984 | 51 | M | Town | Gold Membership | No | Without Offers | Desktop | Fiber_Optic | 24 | 312.330000 | 63446.71 | 2.00000 | 778.700000 | No | Yes | No | Not Applicable | Products always in Stock | 1 | 7 | 10 | 2016 |
| 35822 | 36985 | 12 | F | Village | Premium Membership | No | Gift Vouchers/Coupons | Desktop | Fiber_Optic | 13 | 418.380000 | 56397.21 | 7.00000 | 725.890000 | Yes | Yes | Yes | Unsolved | Products always in Stock | 2 | 25 | 10 | 2016 |
| 35823 | 36986 | 27 | M | Town | Platinum Membership | Yes | Credit/Debit Card Offers | Desktop | Mobile_Data | 13 | 135.830000 | 8225.68 | 16.00000 | 748.570000 | Yes | No | No | Not Applicable | No reason specified | 3 | 7 | 9 | 2015 |
| 35824 | 36987 | 46 | F | Town | Basic Membership | No | Credit/Debit Card Offers | Desktop | Wi-Fi | 2 | -650.682759 | 27277.68 | 6.00000 | 639.510000 | No | Yes | Yes | No Information Available | No reason specified | 4 | 21 | 9 | 2017 |
| 35825 | 36988 | 29 | F | Town | Basic Membership | No | Without Offers | Smartphone | Wi-Fi | 13 | -638.123421 | 11069.71 | 28.00000 | 527.990000 | Yes | No | No | Not Applicable | Poor Customer Service | 5 | 27 | 6 | 2016 |
| 35826 | 36989 | 23 | F | Town | Basic Membership | Yes | Gift Vouchers/Coupons | Desktop | Wi-Fi | 12 | 154.940000 | 38127.56 | 15.96304 | 680.470000 | No | Yes | Yes | Unsolved | Poor Website | 4 | 11 | 9 | 2016 |
| 35827 | 36990 | 53 | M | Village | Platinum Membership | No | Gift Vouchers/Coupons | Smartphone | Mobile_Data | 15 | 482.610000 | 2378.86 | 20.00000 | 197.264414 | Yes | Yes | No | Not Applicable | No reason specified | 3 | 15 | 6 | 2017 |
| 35828 | 36991 | 35 | M | Town | Silver Membership | No | Gift Vouchers/Coupons | Desktop | Mobile_Data | 15 | 79.180000 | 2189.68 | 15.96304 | 719.970000 | Yes | No | No | Not Applicable | Quality Customer Care | 2 | 23 | 10 | 2015 |